-- created by kumiler
-- on 2023/3/11 18:49
-- DESC
CREATE EXTERNAL TABLE `jms_dm`.`dm_rate_order_source_mapping`
(
    `ORDER_SOURCE_code` string COMMENT '订单来源',
    `ORDER_SOURCE_name` string COMMENT '订单名',
    `date_time`         date COMMENT 'sr分区',
    `data_type`         tinyint comment '1揽收，2规划，3时效签收'
)
    COMMENT '达成率订单来源维表'
    PARTITIONED BY (`dt` string COMMENT '分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_rate_order_source_mapping'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );